package com.xdcplus.web.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.xdcplus.web.common.pojo.dto.DmSortingSummaryDTO;
import com.xdcplus.web.common.pojo.entity.DmSortingSummary;
import com.xdcplus.web.common.pojo.vo.DmReworkChartVO;
import com.xdcplus.web.common.pojo.vo.DmReworkSummaryVO;
import com.xdcplus.web.common.pojo.vo.DmSortingSummaryTypeVO;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * <p>
 * 利珀  - 检测设备 Mapper 接口
 * </p>
 *
 * @author xukw
 * @since 2023-11-06
 */
public interface DmSortingMapper extends BaseMapper<DmSortingSummary> {

    List<DmSortingSummary> executeQueryDate(@Param("startDateTimeStr") String startDateTimeStr, @Param("endDateTimeStr") String endDateTimeStr);

    void removeBySummaryDate(String summaryDate);

    List<String> findSummaryDate(@Param("summaryDate") String summaryDate);

    List<DmSortingSummaryTypeVO> querySortingSummaryInfo(DmSortingSummaryDTO dmSortingSummaryDTO);

    List<DmReworkSummaryVO> queryReworkSummaryInfo(DmSortingSummaryDTO dmSortingSummaryDTO);

    List<DmReworkSummaryVO> findReworkSummaryByWeekMonth(DmSortingSummaryDTO dmSortingSummaryDTO);

    List<DmReworkChartVO> queryHistogramData(DmSortingSummaryDTO dmSortingSummaryDTO);


    List<DmReworkChartVO> queryPlatoSummaryData(DmSortingSummaryDTO dmSortingSummaryDTO);

    List<DmReworkChartVO> queryHotSummaryData(DmSortingSummaryDTO dmSortingSummaryDTO);


    List<DmReworkChartVO> querySortingSearchInfo();

    List<DmReworkSummaryVO>  querySummaryForKanban(@Param("deviceType") String deviceType,
                                                   @Param("shiftDate") String shiftDate);



}
